﻿CREATE TABLE [dbo].[Project]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [Name] NVARCHAR(100) NOT NULL, 
    [StartDate] DATETIME NULL, 
    [EndDate] DATETIME NULL, 
    [Description] NVARCHAR(MAX) NULL, 
    [CustomerId] INT NOT NULL, 
    [Deadline] DATETIME NULL, 
    [AddDate] DATETIME NOT NULL DEFAULT getdate(), 
    CONSTRAINT [FK_Project_Company] FOREIGN KEY ([CustomerId]) REFERENCES [Customer]([Id])
) 
